| Song | Album | Recording |
|---|---|---|
| Sweet Lorraine | Radio and Recording Rarities (Cavallaro) | 842 |
| " | Let's Dance with the Tony Pastor Orchestra | 2046 |
| " | Swing Era, Music of 1944-1945 | 5349 |
| " | Dick Jurgens and His Orchestra 1938 | 7773 |
| " | Kaleidoscope | 10178 |
| " | This Is the Life | 11647 |
SELECT PCS.Name AS "Song", ALB.Name AS "Album", REC.ID AS "Recording" FROM Recordings REC JOIN Pieces PCS ON PCS.ID = REC.Piece_FK JOIN Albums ALB ON ALB.ID = REC.ALBUM_FK WHERE PCS. Name = "Sweet Lorraine"